const connection = require('../app/database')

class LabelService {
  async create(name) {
   const statement = 'INSERT INTO label(name) VALUES(?)'
    const [result] = await connection.execute(statement, [name])
    return result  
  }

  // 判断名字是否在labels表中
  async queryLabelByName(name) {
    const statement = 'SELECT * FROM label WHERE name = ?'
    const [result] = await connection.execute(statement, [name])
    return result
  }
}

module.exports = new LabelService()

